SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrCategoriasDeSuborganizaciones
AS

SELECT     IdCategoria AS ID, Descripcion + ' (' + Mnemo +')' as Descripcion
FROM         dbo.tb_CategoriasDeSuborganizaciones

GO
GRANT SELECT ON  [dbo].[vwrCategoriasDeSuborganizaciones] TO [Alumnos]
GRANT SELECT ON  [dbo].[vwrCategoriasDeSuborganizaciones] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vwrCategoriasDeSuborganizaciones] TO [SoloVer]
GO
